This database maintains information on various field trips.
How to use this solution
You can use the database to record information about past trips, and you can also use it to plan upcoming trips.
How to customize this solution
Create reports that focus on different aspects of the field trips, such as the price, attendance, distance, or interests and objectives. You could also add a field to record whether the field trip supervisor felt that the trip was worth repeating.
Form View - Location
A List View
Field Trip Report
Information
Report Menu
Form View - Interest
Form View - Objectives
Form View - LocationB
ContactB
CityB
ZIP CodeB
Site PhoneB
,A InterestsB
Travel DistanceB
TimeB
CostB
OpenB
CloseB
Field Trip GoalsB
AttendenceB
GradeB
Special ConsiderationsB
Field Trip TitleB
StateB
PhoneB
DurationB
Extended PriceB
Subtotal
ObjectivesB
AA Record IDB
Date CreatedB
Date ModifiedB
Created ByB
Last LayoutB
A List ViewB
Your Own
Buttonm
Your Own
Buttonn
Recordo
Delete
Recordp
Recordq
Reportsr
View As
Lists
View As
Formt
Closeu
Enter Location for Field Trip
Your Own
Buttonm
Your Own
Buttonn
Recordo
Delete
Recordp
Recordq
Reportsr
View As
Lists
View As
Formt
Closeu
Enter Location for Field Trip
g Location
Contact
Address
Phone
Trip Title
Academic Fulfillment
Travel Distance
Attend
Children
Adult
Price
Subtotal
Duration (hrs)
ZIP code
Hours
Date
Interest/
Objectives
Notes
Location
Close
Field Trip ReportB
Your Own
ButtonZ
Your Own
Button[
Record\
Delete
Record]
Record^
Reports_
View As
List`
View As
Forma
Closeb
Infoc,Click to see more information for Field Tripi
Field Tripj
Locationk
Contactl
Phone
InformationB
Your Own
Buttont
Reportsu
View As
Listv
View As
Formw
Closex
Info{
Page ##}
Field Trip Summary
Title
Location
Contact
Phone
Your Own
Buttont
Reportsu
View As
Listv
View As
Formw
Closex
Info{
Page ##}
Field Trip Summary
Title
Location
Contact
Phone
Report MenuB
Your Own
ButtonI
ReportsJ
View As
ListK
View As
FormL
CloseM
InfoO*Information about the Field Trips solutionP
Info for this Solution
on about the Field Trips solutionP
Info for this Solution
Your Own
ReportB
Your Own
ReportC
Your Own
ReportD
Field Trip
SummaryE
Your Own
ButtonF
ReportsG
View As
ListH
View As
FormI
CloseJ
InfoK>Click on any of these buttons to preview the respective reportL
Select a report
ButtonF
ReportsG
View As
ListH
View As
FormI
CloseJ
InfoK>Click on any of these buttons to preview the respective reportL
Select a report
Form View - InterestB
Your Own
ButtonB
ReportsC
View As
ListD
View As
FormE
CloseF
Form View - ObjectivesB
Your Own
Buttonm
Your Own
Buttonn
Recordo
Delete
Recordp
Recordq
Reportsr
View As
Lists
View As
Formt
Closeu
,Enter Interest and Objectives for Field Trip
Interest
Goals/Objectives
Interest/
Objectives
Notes
Location
Trip Title
Academic Fulfillment
Duration (hrs)
Date
Your Own
Buttonm
Your Own
Buttonn
Recordo
Delete
Recordp
Recordq
Reportsr
View As
Lists
View As
Formt
Closeu
Enter Notes for Field Trip
Interest/
Objectives
Notes
Location
Trip Title
Academic Fulfillment
Duration (hrs)
Date
Notes/Directions
Special Considerations
09/20/95b*Downtown Los Angeles near the I-5 and I-10e
Artsf
San Francisco Synphonyg
1 AnyStreeth
William Smithi
Anytownj
99999lh- Many different types of cultural music played.
- Large open area for relaxing.
- Speaker at each venuen
3 mip
10:00r
8:00 PMt
5w9- Interpreter for hearing impaired
- Not enough restroomsx
Introduction to Musicy
415-999-9999{
105~~- How many different forms of music.
- What instruments are used?
- Difference between wood instruments and brass instruments?
10/01/95
10/05/95bWHighway 101 to Highway 156 west
Highway 156 to Highway 1 South to Monterey Park (beach)e
Sciencef
Monterey Bay (beach)g
Monterey Beach Parkh
Joe LifeGuardi
MontereylJ- Many tide pools at low tide.
- Various forms of sealife.
- Warm weather.n
60 mip
2.00q
8:00r
5:00t
No handicap ramps.x
Tide Pool Discoveryy
408-555-4200{
Your Own
ButtonB
ReportsC
View As
ListD
View As
FormE
CloseF
Dial Phone
Cancel
Specify Field
Use Dialing Preferences
Phone Number
Field Value
Number
Sort by Field Trip Title
Sort by Site Name
Sort by Contact
Information
A List View
Report Menu
Helvetica
Geneva
Times
Times New Roman
Arial
)=400
Cancel
You did not enter any find criteria; all records will be displayed.C)
Cancel
No records match this request.E)
Information
List View
Report Menu
Sort by Field Trip Title
Sort by Site Name
Sort by Contact
Field Trip Summary
Open Script
Dial Phone
Field Trip Summary
Open Script
MS Sans Serif
wwwwww
ffffff
UUUUUU
DDDDDD
3333B
""""""
#11#22122"3!
"#""3"129
C3C3C34C4C3CC43C
DDCD4DD4CDDC
4CDD4E4ET
TEETEETUETUETUDUDEETUDTUE[
dUTeETeETeEUFTUTUFTUUTeK
EUeFFEUFEUFFUeTeVFeUUdVEEk
ffFdeefeefddfDeVdfEdfFdffk
eVefefe
VvffVefVVefUe\
fvfgfwffv
ggvgvv
gvwxgwghg
vhgvvww
wwwwww
ffffff
UUUUUU
DDDDDD
3333B
""""""
wwxwwxw
ggvgvv
gvwxgwghg
vhgvvww
fvfgfwffv
eVefefe
VvffVefVVefUe\
ffFdeefeefddfDeVdfEdfFdffk
EUeFFEUFEUFFUeTeVFeUUdVEEk
UTdUTeETeETeEUFTUTUFTUUTeK
TEETEETUETUETUDUDEETUDTUE[
4CDD4E4ET
D4DD4CDDC
C3C3C34C4C3CC43C
"#""3"129
#11#22122"3!
Ejwwg
wwxwwxw
(LIST
LISTAZAppliances
Clothing
Electronics
Furniture
Garden
Hobbies
Jewelry
Linen
Tools
Utility
VDEFA(
(LIST
LISTA
Attic
Basement
Bathroom - 1
Bathroom - 2
Bedroom - Master
Bedroom - 1
Bedroom - 2
Bedroom - 3
Bedroom - 4
Dining Room
Family Room
Game Room
Garage
Kitchen
Living Room
VDEFA(
Category ListB
Location List
wwwwww
ffffff
UUUUUU
DDDDDD
wwffeffg@
veUEDDCC
vUTDD44
vUDDC32
#""#
weUDD3
veTDC2233#3#2
wUDDC3##"
vUTD3#22
vUDDC
fUD42233##3#"!
vTDCC##"
eUDC3223##
fTD4C3##23#""
uTDC3323#2""!
22"2"
##2"!
fTDD33#22""
vUDC32"2""
WUTC22
eTD3#""
GDC32"!!
eD3#"!
T32""
wwwwww
ffffff
UUUUUU
DDDDDD
#4EWp
"4EVx
#3EVg
"4DUg
"#4DVg
24EVgy
"34EVw
##4Efw
""3DUgw
""33DUfw
""34DVgx
""#34EVgx
"#33DEfw
" 234DUfw
2""2334DEVgx
3 4DEUfwx
3 DDUVgw
D EUUfwx
UDDEUUfgw
U Vfgwx
eUVfgww
"%UR
UD33D
AD@D@
AD@D@
B"#B@
B"#B"$
4"2$B"#B"#C
2$""#B"#C0
4"2#B"#C0
2$B"D0#C0
4""#C0
44444
CCCCC 44444 CCCCC
$42"
wwwwww
ffffff
UUUUUU
DDDDDD
3333B
""""""
#11#22122"3!
"#""3"129
C3C3C34C4C3CC43C
DDCD4DD4CDDC
4CDD4E4ET
TEETEETUETUETUDUDEETUDTUE[
dUTeETeETeEUFTUTUFTUUTeK
EUeFFEUFEUFFUeTeVFeUUdVEEk
ffFdeefeefddfDeVdfEdfFdffk
eVefefe
VvffVefVVefUe\
fvfgfwffv
ggvgvv
gvwxgwghg
vhgvvww
bRBBP0
@@BA@
JJJJ
!BBBB
"99BB
#9999
$9911
%1111
&))))
'!!!!
*00**-
*00-00
00*0)
00*&0#
## !0*!%00+#!*0##-0'"0*#%00.!
UUUUU
(*)(%,3&
)%+@6)
",30,)%
#*>A6332+$"!
25,878
#&$690*"
!)0,++)(
"%/66435/'#
+3;4*=
!#,@9,)+,(""(-/,,*,1!
!$&(265389,#!$$
'275?
$*23/$
$),-..)''
!$&)(-5439@1!!&*-3/)!!%6B)
)220(!$*.,,.'
!$&*,*023:?B+*.,/3254.'
"++,3/(.584.,"
!#&+/-./3:9@G@60/16883)!
$++//'(9CD>4.$$
$%)*-//2693,.075-&)3792,$
")-1347<>@G71(!
**)&'*.0350+%(=A2'%)579<94(
+/11!
!%'),342)1?=0)"
.1,$',-01)*).AG6-/048:<
/2583$%+66/%
%)++*),+&%06,%$#
!/40')-/31$$,@HFC<6887:==@B7%!
6A235,%
+,/13.%#"(16+
!#$(04-$&+,+$
%2>D6,59:989889=0
,.22<=33*
.22671#
!!&/42&
*1$&+,/3779733,
$$PQ
/004B6*
!$$ $))'/3)
%&$&.7;4
)2$)*3-)466/%$
!),02+'
%$5)%*+%$!
(+'0:==4
$+,,1643"%)"
!)/1)*+
+7=-%%&$!
!3)3=.
%&*/3113
!$$PQ
',4-%)/)
,6/%$$"
+(!<-
%),0354-
.13-&,-*
14'$$!
%))&%$!
'3*$$"
!&$%3
&%"%&
9836'
)%%!
$*)++"
.-/:%
!"&)()15,
)" /.-+)!
//6B&
#'*,.42$
$/,-*%
IF1A1
"%.2/-*#!
$/.,*($!#$"%PQ
#57-*'$#"$&'
..//.-,)'(.212PQ
",,)&%'.;<6/+',,)%!
'//,+//*)+.4:=>PQ
$(&(),5?@:2/,,''*$
-!,,%.0%)./7
#43((+9CA=3+N
&*)2!$96;;48@??PQ
)/01%$
#3/').:@<3)$&)!
/)4$%)8=A@?><@PQ
!.0/.+//./1//*
*.').3784/%
,,#%()25:<99=PQ
%10//O
0 /+134,.25653."
)++-!
# %0,*,384'%PQ
42//11/&(/563135650(
(./36$
!"23.,27-
6:=<)&931-13-!$.69433563+
,/258 #$,96-37)$!
38;?B>;63/.22.-068934673(
,638<6$
*),/6."')==138*$)PQ
35:=@B>953-/1.-368<:8995&
%668:9(
)$'*.:&$*==8/,
-19=@CA>:83+2.,0157:
!""/88$
!)*# 6/0%Q
&' !$*38,.<;60"
+07=@CD=6>@.*)&(*-03;@@<-
6.3/%
#/23989=2,*%
/039>B@ "9E7,)+/3667:?CE/!"
$$%199207/
9K8@)
3933"
!0042381%$(.-)56PQ
556:=@@
5C958=BGGA96;='"+-
!!%.R
94.6BDCFM='(204967&
//2346%
$59232$PQ
:9<@?@C% 6D;;CJLONG952
(9304=FCDDE>%
$,585'
!.//11'$/;81$
9:CE><D3,5G@@HF>IF94)
$#%+*159C=:>FG)
*31*#
$/51#
89C=.!:9=C<9AFGS
CA7&(
/%3%!'+5A<6=C>$
-672.3<<961.%!
,,%=<9/69/02.
"773//33/,+)
/1$'9<3)"
069850(*)'%
%/+$
!#34
%0<PQ
%"$:C9.*$
!+6@PQ
"$$6CD>>5
!##()
".;CPQ
%'0>GFA:378+&&%$$,&
,:CPQ
$(,0V
27CGG@6681//,)%$/
'7CPQ
!%*/1,/44CC;6547@=2*!%.$
%;CPQ
'$)=3
#%)*())3DLHB
?MB9/% !
"'6?6$
*;=PQ
$%&,9D6
!$%#"&)-:FIJHFGFBN@91)%"#(,/./:/#$-46PQ
!)/38;@(
"$$!"+29?DGIJKMLEIC83)'&-7:73)%$!!,5:PQ
+/0,$%&%%,26:5)
"$%&(/7;<=BGIJIGMG=953'%(1<<63/!
$*.8PQ
6=@?<3),3:8$
!&((),3=;::=EHIC:<F3)'""#&+/,',
#&(0PQ
FC8:CF@7/08<(
"'()*,169?:6=C=2..3'"
"%&)PQ
HD99=A@9534/
!26(%5,
! !),''*-16<@=430/,+/)!
??979>@@:-!
!$+%-*),/37<@:2/-*)+*"
4?=95;@@9&
*#%.,/136884/,)'),,%)+(%$$
/>C:13?@9)$
!!89+
!)$%*-/13321/,Z
*3*)-/0/+&$$!
6A:0,8B=1+)/68.%/(,9=2%
")$"%)-02331/31)/().241+%##!
*79/)/:<651/33)2<8.6=9.
!$%,56643/75,'&).340+!$$%#!
.5.)/46682%#$$-973:=<7[
!$'+4:964063+(
,33/+(&'),*)'#
"%%.2379:1&"%(&.36@?@D5
!$%')/8:86>=2)&!!-231
34772+*
&46339C@4+,3/)/:<D/8J='
"%'))+336@3(/)%#%,34569<=?CE5,)!
#'21
.7@C>9;99<9@CAE05J?,%$(.33/+,/26/)(,&
#,0258<?ADGE2 "'(#
"%),,/6983$
&4<9+4DD>?J>/*-6;<6,,/25.))3,'
",.0369;=AGE.
!%%(,.040'
2A?EA4*+/683*.493/($!/-,
0246689:AC7%
$%##(.23&
:96,#"%)*(%(364,%"!!"560&)/<9;989;>3$
"03., PQ
UUUUUU
wwwwww
UUUUUU
wwwwww
~ffff
ffffff
ffff33
ff33ff
ff3333
33ffff
33ff33
333333
wwwwww
UUUUUU
DDDDDD
""""""
Helvetica
Geneva
Times
Times New Roman
Arial
- Introductions to Sealife?
- Describe different forms of life?
- Sea water vs. fresh water life?
- How is food supply supplied?
10/01/95
06/15/95b0I-40 to Great Waters Parkway turn right to park.e